/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package posartenobsa;

import SQL.Insertar;
import com.sun.data.provider.impl.CachedRowSetDataProvider;
import com.sun.rave.faces.data.DefaultSelectItemsArray;
import com.sun.rave.web.ui.appbase.AbstractPageBean;
import com.sun.webui.jsf.component.Alert;
import com.sun.webui.jsf.component.DropDown;
import com.sun.webui.jsf.component.PasswordField;
import com.sun.webui.jsf.component.TextField;
import com.sun.webui.jsf.model.SingleSelectOptionsList;
import javax.faces.FacesException;
import javax.faces.convert.IntegerConverter;
import javax.faces.event.ValueChangeEvent;

/**
 * <p>Page bean that corresponds to a similarly named JSP page.  This
 * class contains component definitions (and initialization code) for
 * all components that you have defined on this page, as well as
 * lifecycle methods and event handlers where you may add behavior
 * to respond to incoming events.</p>
 *
 * @version A_Socio.java
 * @version Created on 19/03/2012, 07:53:31 PM
 * @author Fabio
 */
public class A_Socio extends AbstractPageBean {

    String Nombresocio, Apellidosocio, Docsocio, Telefonosocio, Direccionsocio;
    String SQL;
    Insertar in = new Insertar();
    String NNombre, NApellido, NDocumento, NDireccion, NTelefono,
            socio, PassMod, Passdes, SocioDes;
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">

    /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {
        socioDataProvider.setCachedRowSet((javax.sql.rowset.CachedRowSet) getValue("#{SessionBean1.socioRowSet}"));
    }
    private CachedRowSetDataProvider socioDataProvider = new CachedRowSetDataProvider();

    public CachedRowSetDataProvider getSocioDataProvider() {
        return socioDataProvider;
    }

    public void setSocioDataProvider(CachedRowSetDataProvider crsdp) {
        this.socioDataProvider = crsdp;
    }
    private TextField TFNombresocio = new TextField();

    public TextField getTFNombresocio() {
        return TFNombresocio;
    }

    public void setTFNombresocio(TextField tf) {
        this.TFNombresocio = tf;
    }
    private TextField TFApellidosocio = new TextField();

    public TextField getTFApellidosocio() {
        return TFApellidosocio;
    }

    public void setTFApellidosocio(TextField tf) {
        this.TFApellidosocio = tf;
    }
    private TextField TFIdsocio = new TextField();

    public TextField getTFIdsocio() {
        return TFIdsocio;
    }

    public void setTFIdsocio(TextField tf) {
        this.TFIdsocio = tf;
    }
    private TextField TFTelefonosocio = new TextField();

    public TextField getTFTelefonosocio() {
        return TFTelefonosocio;
    }

    public void setTFTelefonosocio(TextField tf) {
        this.TFTelefonosocio = tf;
    }
    private TextField TFDireccionsocio = new TextField();

    public TextField getTFDireccionsocio() {
        return TFDireccionsocio;
    }

    public void setTFDireccionsocio(TextField tf) {
        this.TFDireccionsocio = tf;
    }
    // </editor-fold>
    private Alert alertaSocioGuardado = new Alert();

    public Alert getAlertaSocioGuardado() {
        return alertaSocioGuardado;
    }

    public void setAlertaSocioGuardado(Alert a) {
        this.alertaSocioGuardado = a;
    }
    private Alert alertaSocioDesactivado = new Alert();

    public Alert getAlertaSocioDesactivado() {
        return alertaSocioDesactivado;
    }

    public void setAlertaSocioDesactivado(Alert a) {
        this.alertaSocioDesactivado = a;
    }
    private Alert alertaContraseñaDes = new Alert();

    public Alert getAlertaContraseñaDes() {
        return alertaContraseñaDes;
    }

    public void setAlertaContraseñaDes(Alert a) {
        this.alertaContraseñaDes = a;
    }
    private Alert alertaSocioModificado = new Alert();

    public Alert getAlertaSocioModificado() {
        return alertaSocioModificado;
    }

    public void setAlertaSocioModificado(Alert a) {
        this.alertaSocioModificado = a;
    }
    private Alert alertaContraseñaM = new Alert();

    public Alert getAlertaContraseñaM() {
        return alertaContraseñaM;
    }

    public void setAlertaContraseñaM(Alert a) {
        this.alertaContraseñaM = a;
    }
    private PasswordField TFPassM_socio = new PasswordField();

    public PasswordField getTFPassM_socio() {
        return TFPassM_socio;
    }

    public void setTFPassM_socio(PasswordField pf) {
        this.TFPassM_socio = pf;
    }
    private TextField TFNDireccion_socio = new TextField();

    public TextField getTFNDireccion_socio() {
        return TFNDireccion_socio;
    }

    public void setTFNDireccion_socio(TextField tf) {
        this.TFNDireccion_socio = tf;
    }
    private TextField TFNTelefono_socio = new TextField();

    public TextField getTFNTelefono_socio() {
        return TFNTelefono_socio;
    }

    public void setTFNTelefono_socio(TextField tf) {
        this.TFNTelefono_socio = tf;
    }
    private TextField TFNDoc_socio = new TextField();

    public TextField getTFNDoc_socio() {
        return TFNDoc_socio;
    }

    public void setTFNDoc_socio(TextField tf) {
        this.TFNDoc_socio = tf;
    }
    private TextField TFNApellido_socio = new TextField();

    public TextField getTFNApellido_socio() {
        return TFNApellido_socio;
    }

    public void setTFNApellido_socio(TextField tf) {
        this.TFNApellido_socio = tf;
    }
    private TextField TFNNombre_socio = new TextField();

    public TextField getTFNNombre_socio() {
        return TFNNombre_socio;
    }

    public void setTFNNombre_socio(TextField tf) {
        this.TFNNombre_socio = tf;
    }
    private DropDown c_SeleSocio = new DropDown();

    public DropDown getC_SeleSocio() {
        return c_SeleSocio;
    }

    public void setC_SeleSocio(DropDown dd) {
        this.c_SeleSocio = dd;
    }
    private DropDown c_SeleDeSocio = new DropDown();

    public DropDown getC_SeleDeSocio() {
        return c_SeleDeSocio;
    }

    public void setC_SeleDeSocio(DropDown dd) {
        this.c_SeleDeSocio = dd;
    }
    private PasswordField TFPassD_socio = new PasswordField();

    public PasswordField getTFPassD_socio() {
        return TFPassD_socio;
    }

    public void setTFPassD_socio(PasswordField pf) {
        this.TFPassD_socio = pf;
    }
    private IntegerConverter c_SeleSocioConverter = new IntegerConverter();

    public IntegerConverter getC_SeleSocioConverter() {
        return c_SeleSocioConverter;
    }

    public void setC_SeleSocioConverter(IntegerConverter ic) {
        this.c_SeleSocioConverter = ic;
    }

    /**
     * <p>Construct a new Page bean instance.</p>
     */
    public A_Socio() {
    }

    /**
     * <p>Callback method that is called whenever a page is navigated to,
     * either directly via a URL, or indirectly via page navigation.
     * Customize this method to acquire resources that will be needed
     * for event handlers and lifecycle methods, whether or not this
     * page is performing post back processing.</p>
     * 
     * <p>Note that, if the current request is a postback, the property
     * values of the components do <strong>not</strong> represent any
     * values submitted with this request.  Instead, they represent the
     * property values that were saved for this view when it was rendered.</p>
     */
    @Override
    public void init() {
        // Perform initializations inherited from our superclass
        super.init();
        // Perform application initialization that must complete
        // *before* managed components are initialized
        // TODO - add your own initialiation code here

        // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
        // Initialize automatically managed components
        // *Note* - this logic should NOT be modified
        try {
            _init();
        } catch (Exception e) {
            log("A_Socio Initialization Failure", e);
            throw e instanceof FacesException ? (FacesException) e : new FacesException(e);
        }

        // </editor-fold>
        // Perform application initialization that must complete
        // *after* managed components are initialized
        // TODO - add your own initialization code here
    }

    /**
     * <p>Callback method that is called after the component tree has been
     * restored, but before any event processing takes place.  This method
     * will <strong>only</strong> be called on a postback request that
     * is processing a form submit.  Customize this method to allocate
     * resources that will be required in your event handlers.</p>
     */
    @Override
    public void preprocess() {
    }

    /**
     * <p>Callback method that is called just before rendering takes place.
     * This method will <strong>only</strong> be called for the page that
     * will actually be rendered (and not, for example, on a page that
     * handled a postback and then navigated to a different page).  Customize
     * this method to allocate resources that will be required for rendering
     * this page.</p>
     */
    @Override
    public void prerender() {
    }

    /**
     * <p>Callback method that is called after rendering is completed for
     * this request, if <code>init()</code> was called (regardless of whether
     * or not this was the page that was actually rendered).  Customize this
     * method to release resources acquired in the <code>init()</code>,
     * <code>preprocess()</code>, or <code>prerender()</code> methods (or
     * acquired during execution of an event handler).</p>
     */
    @Override
    public void destroy() {
        socioDataProvider.close();
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected RequestBean1 getRequestBean1() {
        return (RequestBean1) getBean("RequestBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected ApplicationBean1 getApplicationBean1() {
        return (ApplicationBean1) getBean("ApplicationBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected SessionBean1 getSessionBean1() {
        return (SessionBean1) getBean("SessionBean1");
    }

    public String HPL_AUsuario1_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        return "case1";
    }

    public String HPL_ASocio_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        return null;
    }

    public String hyperlink2_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        return "case2";
    }

    public String HPL_ADeposito_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        return "case3";
    }

    public String HPL_AExposicion1_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        return null;
    }

    public String HPL_Vender_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        return "case5";
    }

    public String tabCUsuario_action() {
        alertaSocioGuardado.setVisible(false);
        return null;
    }

    public void t_Pass1_processValueChange(ValueChangeEvent event) {
    }

    public String b_Guardarusuario_action() {
        //Boton guardar usuario

        Nombresocio = (String) TFNombresocio.getText();
        Apellidosocio = (String) TFApellidosocio.getText();
        Docsocio = (String) TFIdsocio.getText();
        Telefonosocio = (String) TFTelefonosocio.getText();
        Direccionsocio = (String) TFDireccionsocio.getText();
        SQL = "INSERT INTO socio VALUES ('" + Docsocio + "','" + Nombresocio + "','" + Apellidosocio + "','" + Telefonosocio + "','" + Direccionsocio + "',TRUE);";
        in.insertar(SQL);
        alertaSocioGuardado.setVisible(true);
        TFNombresocio.setText(null);
        TFApellidosocio.setText(null);
        TFIdsocio.setText(null);
        TFDireccionsocio.setText(null);
        TFTelefonosocio.setText(null);
        socioDataProvider.refresh();
        return null;
    }

    public String tabMSocio_action() {
        alertaSocioModificado.setVisible(false);
        alertaContraseñaM.setVisible(false);
        return null;
    }

    public String b_Modificarusuario1_action() {

        System.out.println("Entro al boton modificar" + c_SeleSocio.getValue());
        socio = String.valueOf(c_SeleSocio.getValue());
        NNombre = (String) TFNNombre_socio.getText();
        NApellido = (String) TFNApellido_socio.getText();
        NDocumento = (String) TFNDoc_socio.getText();
        NDireccion = (String) TFNDireccion_socio.getText();
        NTelefono = (String) TFNTelefono_socio.getText();
        PassMod = (String) TFPassM_socio.getText();

        if (PassMod.equals("Fabio")) {

            if (NNombre != null) {
                SQL = "UPDATE socio SET nombre_socio = '" + NNombre + "' WHERE cedula =" + socio + ";";
                in.insertar(SQL);
                socioDataProvider.refresh();
            }
            if (NApellido != null) {
                SQL = "UPDATE socio SET apellido_socio = '" + NApellido + "' WHERE cedula =" + socio + ";";
                in.insertar(SQL);
                socioDataProvider.refresh();
            }
            if (NTelefono != null) {
                SQL = "UPDATE socio SET telefono_socio = '" + NTelefono + "' WHERE cedula =" + socio + ";";
                in.insertar(SQL);
                socioDataProvider.refresh();
            }
            if (NDireccion != null) {
                SQL = "UPDATE socio SET direccion_socio = '" + NDireccion + "' WHERE cedula =" + socio + ";";
                in.insertar(SQL);
                socioDataProvider.refresh();
            }
            if (NDocumento != null) {
                SQL = "UPDATE socio SET cedula = '" + NDocumento + "' WHERE cedula =" + socio + ";";
                in.insertar(SQL);
                socioDataProvider.refresh();
            }
            alertaSocioModificado.setVisible(true);
            alertaContraseñaM.setVisible(false);
            TFNNombre_socio.setText(null);
            TFNApellido_socio.setText(null);
            TFNDoc_socio.setText(null);
            TFNDireccion_socio.setText(null);
            TFNTelefono_socio.setText(null);


        } else {
            alertaSocioModificado.setVisible(false);
            alertaContraseñaM.setVisible(true);
        }


        return null;
    }

    public String tabDSocio_action() {
        alertaSocioDesactivado.setVisible(false);
        alertaContraseñaDes.setVisible(false);
        return null;
    }

    public String b_Desactivarusuario1_action() {
       
        Passdes = (String) TFPassD_socio.getText();
        SocioDes = String.valueOf(c_SeleDeSocio.getValue());

        if(Passdes.equals("Fabio")){
        SQL = "UPDATE socio SET socio_activo = FALSE WHERE cedula ='" + SocioDes + "';";
        in.insertar(SQL);
        socioDataProvider.refresh();
        alertaSocioDesactivado.setVisible(true);
        alertaContraseñaDes.setVisible(false);
        }
 else {
        alertaSocioDesactivado.setVisible(false);
        alertaContraseñaDes.setVisible(true);
 }


        return null;
    }

    public String alertaGuardado2_action() {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        return null;
    }

    public String alertaSocioModificado_action() {
        // TODO: Replace with your code
        return null;
    }
}
